select * from products where pro_name like '%ball%gown%' or pro_des like '%ball%gown%'union all select * from products where (pro_name like '%ball%' or pro_des like '%ball%') or(pro_name like '%gown%' or pro_des like '%gown%') and (pro_name not like '%ball%gown%' or pro_des not like '%ball%gown%')
Taffeta One Shoulder Royal Blue Dama Quinceanera Dress with Pleat
V-neck Aqua Blue Floor-length Dama Gown With Pleat in Chiffon
Column Strapless Dama Dress in Lilac with Belt and Ruches
White and Hot Pink A-line Straps Mini-length Quince Dama Dresses
Orange Empire V-neck Knee-length Chiffon Ruch Party Dama Dresses
Olive Green Mini-length Sweetheart Cocktail Dresses For Dama Pleated
Elegant Strapless Quinceanera Dress with Beading and Appliques
Fabulous Light Blue Strapless Beading Quinceanera Dresses Gowns
Magnificent Hot Pink Strapless Ruching Appliques Quinceanera Dress
Fashionable Quinceanera Gowns Dresses with Beading and Pick-ups
Ruffles Sweetheart Beaded Fuchsia Quinceanera Gowns of Sweet 16
Baby Pink Sweetheart Quinceanera Gown with Appliques and Overskirt
Popular Purple Sweet Sixteen Dresses with Embroidery and Pick-ups
Custom Made Strapless Embroidery Quinceanera Dress with Overskirt
Exquisite Halter Embroidered Olive Green Dress for Quinceaneras
Unique Lavender Sweetheart Quinceanera Gowns with Appliques
Olive Green Sweetheart Organza Beading and Ruffle Dresses 15
Wonderful Spring Green Paillette Sweet 16 Dress with Appliques
Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket
Princess Off the Shoulder Prom Dress with Appliques in Organza
Ruffled and Ruched Quinces Gown For Military Ball with Appliques
Taffeta and Tulle Quince Dress in Teal and White with Floor-length
Multi-color Sweetheart Sweet 15th Dress with Ruffles and Appliques
White and Olive Green Ball Gown Quince Dress in Taffeta and Tulle
Ball Gown Dress Quinces with Embroidery in White and Turquoise
Floor-length Strapless Dress for Sweet Sixteenth with Embroidery
Sweetheart Beaded Quinces Dress in Light Blue with Tulle Fabric
Green and Black Quinceanera Dress with V-neck Straps and Beading
Lilac Quinceanera Gown with Organza Ruffles and Appliques
Strapless Quinces Dress with Ruffles and Appliques in Coral Red